﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default3.aspx.cs" Inherits="Default3" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
        <div style="margin: 0 auto; border: 3px solid #808080; height: auto;">
            <h1 style="text-align: left; color: #b06600">&nbsp;&nbsp;Using LINQ: Create, Update, Delete Database: LINQDEMO</h1>
            <table style="width: 100%;">
                <tr>
                    <td>&nbsp;&nbsp;Username: </td>
                    <td>&nbsp;&nbsp;<asp:TextBox ID="txtUSername" runat="server" Width="347px"></asp:TextBox></td>
                    <td>&nbsp;&nbsp;<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ErrorMessage="RequiredFieldValidator" ControlToValidate="txtUSername" ForeColor="Red"></asp:RequiredFieldValidator></td>
                </tr>
                <tr>
                    <td>&nbsp;&nbsp;Password: </td>
                    <td>&nbsp;&nbsp;<asp:TextBox ID="txtPassword" runat="server" Width="347px"></asp:TextBox></td>
                    <td>&nbsp;&nbsp;<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ErrorMessage="RequiredFieldValidator" ControlToValidate="txtPassword" ForeColor="Red"></asp:RequiredFieldValidator></td>
                </tr>
                <tr>
                    <td>&nbsp;&nbsp;Fullname: </td>
                    <td>&nbsp;&nbsp;<asp:TextBox ID="txtFullname" runat="server" Width="347px"></asp:TextBox></td>
                    <td>&nbsp;&nbsp;<asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ErrorMessage="RequiredFieldValidator" ControlToValidate="txtFullname" ForeColor="Red"></asp:RequiredFieldValidator></td>
                </tr>
                <tr>
                    <td>&nbsp;&nbsp;Address: </td>
                    <td>&nbsp;&nbsp;<asp:TextBox ID="txtAddress" runat="server" Width="347px"></asp:TextBox></td>
                    <td>&nbsp;&nbsp;<asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" ErrorMessage="RequiredFieldValidator" ControlToValidate="txtAddress" ForeColor="Red"></asp:RequiredFieldValidator></td>
                </tr>
                <tr>
                    <td>
                        &nbsp;&nbsp;<asp:Button ID="btnRefresh" runat="server" Text="Refresh" Width="100px" BackColor="#333333" ForeColor="#CCCCCC" CausesValidation="False" OnClick="btnRefresh_Click" />
                    </td>
                    <td>
                        &nbsp;&nbsp;<asp:Button ID="btnAdd" runat="server" Text="Add New" Width="117px" BackColor="#333333" ForeColor="#CCCCCC" OnClick="btnAdd_Click" />
                        &nbsp;&nbsp;<asp:Button ID="btnUpdate" runat="server" Text="Update" Width="117px" BackColor="#333333" ForeColor="#CCCCCC" OnClick="btnUpdate_Click" />
                        &nbsp;&nbsp;<asp:Button ID="btnDelete" runat="server" Text="Delete" Width="117px" BackColor="#333333" ForeColor="#CCCCCC" OnClick="btnDelete_Click" />
                    </td>
                    
                </tr>
            </table>
        </div>
        <div style="height: auto;">
            <asp:GridView ID="gvwData" runat="server" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="4" ForeColor="Black" GridLines="Horizontal" Width="100%">
                <FooterStyle BackColor="#CCCC99" ForeColor="Black" />
                <HeaderStyle BackColor="#333333" Font-Bold="True" ForeColor="White" />
                <PagerStyle BackColor="White" ForeColor="Black" HorizontalAlign="Right" />
                <SelectedRowStyle BackColor="#CC3333" Font-Bold="True" ForeColor="White" />
                <SortedAscendingCellStyle BackColor="#F7F7F7" />
                <SortedAscendingHeaderStyle BackColor="#4B4B4B" />
                <SortedDescendingCellStyle BackColor="#E5E5E5" />
                <SortedDescendingHeaderStyle BackColor="#242121" />
            </asp:GridView>
        </div>
    </form>
</body>
</html>
